"""add certificates fields

Revision ID: add_certificates_fields
Revises: previous_revision
Create Date: 2024-03-21

"""
from alembic import op
import sqlalchemy as sa

# revision identifiers, used by Alembic.
revision = 'add_certificates_fields'
down_revision = 'previous_revision'
branch_labels = None
depends_on = None

def upgrade():
    # 添加certificates字段
    op.add_column('employee', sa.Column('certificates', sa.Text(), nullable=True))
    # 添加awards字段
    op.add_column('employee', sa.Column('awards', sa.Text(), nullable=True))
    # 添加skills字段
    op.add_column('employee', sa.Column('skills', sa.Text(), nullable=True))

def downgrade():
    # 删除certificates字段
    op.drop_column('employee', 'certificates')
    # 删除awards字段
    op.drop_column('employee', 'awards')
    # 删除skills字段
    op.drop_column('employee', 'skills') 